pgsnap software package provides PostgreSQL report tool, you can install in your Ubuntu 14.04 LTS (Trusty Tahr) by running the commands given below on the terminal,
$ sudo apt-get update $ sudo apt-get install pgsnap
pgsnap is installed in your system.
Make ensure the pgsnap package were installed using the commands given below,
$ sudo dpkg-query -l | grep pgsnap *
You will get with pgsnap package name, version, architecture and description in a table
| Distro | Ubuntu 14 04 lts trusty tahr |
| Section | Miscellaneous |
| Package | pgsnap |
| Version | 0.7.0-1 |
| Description | PostgreSQL report tool |
| Sub Section | misc |